Use YongTest;
Go
Print 'Database selected';

Print 'Check Table exists';
If Exists(select 1 from Sys.objects where object_ID=object_ID('Departments') AND type in (N'U'))
Begin
	Print 'Table Exists';
	Drop Table Departments;
	Print 'Departments Table Dropped';
END



Print 'Creating Departments Table ';
go

Create Table Departments
(
	DepartmentID char(2) primary key not null,
	DeptName char(15) not null
)
with
(
	Data_compression=ROW
)
